Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Configuring a remote DataServer

In configurations that include a remote host, two DataServer processes run on the host machine:

Broker — The DataServer broker (_probrkr.exe) or the broker for the Progress Explorer on the host machine determines the types of requests coming over the network and starts (spawns) the appropriate DataServer (_msssrv.exe) for the client process.
DataServer — The DataServer (_msssrv.exe) on the host machine accesses the MS SQL Server database and communicates with the client process.
Note: The OpenEdge MS SQL Server DataServer component is an ODBC client with respect to the MS SQL Server database configuration even though from the OpenEdge point-of-view it resides on the server machine. As a result, your MS SQL Server client software must reside on the machine from which the DataServer and the broker processes will execute. In the remote DataServer configuration, the OpenEdge client component requires no special software or configuration; it only requires a standalone OpenEdge Windows or UNIX client. There are no OpenEdge restrictions regarding the location of the actual MS SQL Server database.

Before you can run the server components, you must configure the DataServer by setting the required environment variables on the host machine. In Windows, you configure the DataServer using the Progress Explorer tool. See the "Configuring with the Progress Explorer" section for details.